ODDFYIELD

Returns the yield of a security with an odd first period.

Syntax

expression.ODDFYIELD(arg1, arg2, arg3, arg4, arg5, arg6, arg7, arg8, arg9);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

Name	Required/Optional	Data type	Default	Description
arg1	Required	ApiRange	ApiName	number
arg2	Required	ApiRange	ApiName	number
arg3	Required	ApiRange	ApiName	number
arg4	Required	ApiRange	ApiName	number
arg5	Required	ApiRange	ApiName	number
arg6	Required	ApiRange	ApiName	number
arg7	Required	ApiRange	ApiName	number
arg8	Required	ApiRange	ApiName	number
arg9	Required	ApiRange	ApiName	number

Returns

number

Example

var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.ODDFYIELD("1/1/2017", "6/1/2019", "12/1/2016", "3/15/2017", 0.06, 90, 100, 2));